﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using FluentMigrator;

namespace Coevery.Database.Migrations
{
    [Migration(20121010172420)]
    public class _20121010172420_InitPickListMappingTable : Migration
    {
        public override void Up()
        {
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "AC4348C5-F8E1-42B8-8B4C-00F9035BC409", ColumnMappingId = "9AD4EF1F-AD86-4A69-B0DC-3F2DDFA2BA78", TargetValue = 12, SourceValue = "Other" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "701B5F3B-F027-4502-8033-072E37241F35", ColumnMappingId = "8FD66305-4FC1-4B8A-B1AF-F0076D94C824", TargetValue = 2, SourceValue = "Not Approved" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "B3FF8F1D-C8FD-4B8E-898D-07C8F7439787", ColumnMappingId = "BF5B63EE-7AC9-4CEB-9324-1B38A5655EF6", TargetValue = 2, SourceValue = "High" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "1E011BD5-C541-4B7F-8966-0921D28369D4", ColumnMappingId = "43FCA676-F85E-4AE5-8DCE-F6EB29E5A428", TargetValue = 5, SourceValue = "Confirmed" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "D6BCD7DF-36E7-421E-8A23-0BEEB5EE05E7", ColumnMappingId = "592D2D25-6F91-405B-B845-B3C99C96391B", TargetValue = 7, SourceValue = "Proposal/Price Quote" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "00543CAB-B818-4907-812E-0ECF28252DE4", ColumnMappingId = "BF5B63EE-7AC9-4CEB-9324-1B38A5655EF6", TargetValue = 1, SourceValue = "Very High" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "55292AEB-B29C-458E-9BCC-21001066D57E", ColumnMappingId = "592D2D25-6F91-405B-B845-B3C99C96391B", TargetValue = 10, SourceValue = "Closed Lost" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "F4C314C5-DDEF-48F9-8B44-230F87E9B80C", ColumnMappingId = "1B08DEA0-534E-42AC-B4CC-A480DAA5E326", TargetValue = 2, SourceValue = "Assigned" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "214B54C6-EFEB-40B4-99B1-25CB99610B14", ColumnMappingId = "43FCA676-F85E-4AE5-8DCE-F6EB29E5A428", TargetValue = 3, SourceValue = "Delivered" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "B220E2DD-5EF9-486E-842A-285500B795D3", ColumnMappingId = "1B08DEA0-534E-42AC-B4CC-A480DAA5E326", TargetValue = 3, SourceValue = "In Process" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "EDE5C8B6-0D16-42AD-BF5B-2943D857F9AF", ColumnMappingId = "43FCA676-F85E-4AE5-8DCE-F6EB29E5A428", TargetValue = 7, SourceValue = "Closed Lost" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "3FAFAD70-FFDF-4DE5-85B1-299B87FDC127", ColumnMappingId = "73BDF139-7374-4EE2-BC1D-636ACAABF059", TargetValue = 2, SourceValue = "Head Office" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "88D2DF6C-84C8-48EC-A2EE-2BC29E7ED305", ColumnMappingId = "254A6DD1-C239-47A0-9E70-2B5FF3B04E7F", TargetValue = 1, SourceValue = "Accounting" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "886D2FA4-3E54-460B-8910-2D5094E4D856", ColumnMappingId = "BF5B63EE-7AC9-4CEB-9324-1B38A5655EF6", TargetValue = 4, SourceValue = "Worthy of a Try" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "BDF30411-4803-44F4-80BE-34AEA7875B90", ColumnMappingId = "9AD4EF1F-AD86-4A69-B0DC-3F2DDFA2BA78", TargetValue = 10, SourceValue = "Supplier" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "8F247850-9B69-40D0-89C7-3640160BA704", ColumnMappingId = "FC94027D-DE2D-427F-B17C-AD54B9709A43", TargetValue = 1, SourceValue = "Web Site" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "DB7A6842-40E1-4B63-A413-37743D20A86A", ColumnMappingId = "1B08DEA0-534E-42AC-B4CC-A480DAA5E326", TargetValue = 1, SourceValue = "New" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "7B3152E1-1EED-4733-9F12-3CB876C68E42", ColumnMappingId = "73BDF139-7374-4EE2-BC1D-636ACAABF059", TargetValue = 5, SourceValue = "Partner" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "F2E623BA-0F36-454F-90DC-3D7A9C5BAC46", ColumnMappingId = "73BDF139-7374-4EE2-BC1D-636ACAABF059", TargetValue = 1, SourceValue = "Web Site" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "C188D748-B25D-41D6-A214-3FFD8624C8EF", ColumnMappingId = "9AD4EF1F-AD86-4A69-B0DC-3F2DDFA2BA78", TargetValue = 3, SourceValue = "Customer" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "360E7416-3C79-42C5-96AE-4119013FE5FF", ColumnMappingId = "FC94027D-DE2D-427F-B17C-AD54B9709A43", TargetValue = 5, SourceValue = "Partner" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "258B09C3-4EB1-40FE-B522-4A0B39981804", ColumnMappingId = "9AD4EF1F-AD86-4A69-B0DC-3F2DDFA2BA78", TargetValue = 2, SourceValue = "Consultant" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "ED563CAD-48E5-4605-95B4-4A438A52EAF0", ColumnMappingId = "254A6DD1-C239-47A0-9E70-2B5FF3B04E7F", TargetValue = 8, SourceValue = "Consumer Services" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "300E2678-9434-4F12-AC7D-4A7F89535634", ColumnMappingId = "73BDF139-7374-4EE2-BC1D-636ACAABF059", TargetValue = 6, SourceValue = "Self Generated" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "CCF19DA0-68FD-4509-A6AA-4EFE66750EF1", ColumnMappingId = "9AD4EF1F-AD86-4A69-B0DC-3F2DDFA2BA78", TargetValue = 8, SourceValue = "Prospect" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "1872A04D-8842-4D0F-B737-5182A2E6DFF7", ColumnMappingId = "1B08DEA0-534E-42AC-B4CC-A480DAA5E326", TargetValue = 4, SourceValue = "Converted" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "41B83FD7-D0F4-4907-B367-5199D29DDE77", ColumnMappingId = "8FD66305-4FC1-4B8A-B1AF-F0076D94C824", TargetValue = 1, SourceValue = "Approved" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "AA233206-00A9-4AC0-BA2C-52CA15FF6CDF", ColumnMappingId = "FC94027D-DE2D-427F-B17C-AD54B9709A43", TargetValue = 4, SourceValue = "Cold Call" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "26D8AA12-CBA4-45DE-8BA5-56DF3C334473", ColumnMappingId = "254A6DD1-C239-47A0-9E70-2B5FF3B04E7F", TargetValue = 5, SourceValue = "Building Supply Retail" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "05A57854-DBBF-4775-923B-5E46332BFACB", ColumnMappingId = "592D2D25-6F91-405B-B845-B3C99C96391B", TargetValue = 5, SourceValue = "Id. Decision Makers" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "F7DCEA87-DA9C-49AD-84AF-6125D9CFB32F", ColumnMappingId = "FC94027D-DE2D-427F-B17C-AD54B9709A43", TargetValue = 7, SourceValue = "Employee" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "6E7D1263-083D-4445-AD49-6372E0E07A2F", ColumnMappingId = "73BDF139-7374-4EE2-BC1D-636ACAABF059", TargetValue = 3, SourceValue = "Existing Customer" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "602B7868-2CC5-4403-B011-669E5FAA1601", ColumnMappingId = "254A6DD1-C239-47A0-9E70-2B5FF3B04E7F", TargetValue = 6, SourceValue = "Technology" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "AAA3B57A-A7E0-406D-9784-6DD1C8C6AA5C", ColumnMappingId = "9AD4EF1F-AD86-4A69-B0DC-3F2DDFA2BA78", TargetValue = 6, SourceValue = "Influencer" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "FD971FD4-DDDD-406A-A076-711231B47B58", ColumnMappingId = "FC94027D-DE2D-427F-B17C-AD54B9709A43", TargetValue = 3, SourceValue = "Existing Customer" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "53A245D7-8B21-43D2-9E63-745C4F073B0D", ColumnMappingId = "73BDF139-7374-4EE2-BC1D-636ACAABF059", TargetValue = 9, SourceValue = "Other" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "CBF70A81-2AE3-493F-94A7-75D57B2193A0", ColumnMappingId = "F2D9229A-CF2B-40E2-8BD2-69BE58FB57BD", TargetValue = 5, SourceValue = "Plan" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "09E5469E-8789-4DD7-88C4-761C89B32CC1", ColumnMappingId = "43FCA676-F85E-4AE5-8DCE-F6EB29E5A428", TargetValue = 1, SourceValue = "Draft" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "678084F2-2C4C-44C4-AE6B-7860FF732EF2", ColumnMappingId = "592D2D25-6F91-405B-B845-B3C99C96391B", TargetValue = 1, SourceValue = "Prospecting" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "C73EF229-CDA6-45E4-995C-790DAF381703", ColumnMappingId = "592D2D25-6F91-405B-B845-B3C99C96391B", TargetValue = 3, SourceValue = "Needs Analysis" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "260910CC-7619-4B9F-9343-80887AB4FB0E", ColumnMappingId = "94A4C5FD-B8B3-4B1A-AA9F-458D7669E9BA", TargetValue = 3, SourceValue = "Finished" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "8F60748C-DD83-48BB-A302-878C758D41EF", ColumnMappingId = "592D2D25-6F91-405B-B845-B3C99C96391B", TargetValue = 6, SourceValue = "Perception Analysis" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "7BB017AF-10EF-4344-ACF4-89F1D90BF725", ColumnMappingId = "F2D9229A-CF2B-40E2-8BD2-69BE58FB57BD", TargetValue = 3, SourceValue = "In Arrear" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "6444A0B0-5244-4BE9-8AED-92182F490D35", ColumnMappingId = "FC94027D-DE2D-427F-B17C-AD54B9709A43", TargetValue = 9, SourceValue = "Other" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "EA40A4E5-902B-44E1-AC28-9295BFFB669C", ColumnMappingId = "73BDF139-7374-4EE2-BC1D-636ACAABF059", TargetValue = 7, SourceValue = "Employee" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "05FB3B66-E635-4E04-8414-95400719BAE8", ColumnMappingId = "9AD4EF1F-AD86-4A69-B0DC-3F2DDFA2BA78", TargetValue = 4, SourceValue = "Investor" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "7C82553E-E02D-4B91-98F9-984D2280C5FA", ColumnMappingId = "FC94027D-DE2D-427F-B17C-AD54B9709A43", TargetValue = 8, SourceValue = "Email" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "F192298C-A918-4D25-B1ED-99891EC70723", ColumnMappingId = "592D2D25-6F91-405B-B845-B3C99C96391B", TargetValue = 8, SourceValue = "Negotiation/Review" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "F33E5D7E-6084-4BCB-98E7-9B606FEA4F46", ColumnMappingId = "1B08DEA0-534E-42AC-B4CC-A480DAA5E326", TargetValue = 6, SourceValue = "Dead" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "F2E658E1-9EDF-4CC8-AA50-9DB31A716FD1", ColumnMappingId = "BF5B63EE-7AC9-4CEB-9324-1B38A5655EF6", TargetValue = 3, SourceValue = "Normal" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "5B87E511-8E0C-49EE-A920-A727AAB2091A", ColumnMappingId = "9AD4EF1F-AD86-4A69-B0DC-3F2DDFA2BA78", TargetValue = 9, SourceValue = "Reseller" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "2B7D1AC0-00F1-4575-B962-A8629033C809", ColumnMappingId = "9AD4EF1F-AD86-4A69-B0DC-3F2DDFA2BA78", TargetValue = 1, SourceValue = "Competitor" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "A7A684DC-5FDB-44C9-9869-AB3DE69EE710", ColumnMappingId = "F2D9229A-CF2B-40E2-8BD2-69BE58FB57BD", TargetValue = 1, SourceValue = "Sent" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "B36A231E-CAE3-45C4-854D-AFBA021421EE", ColumnMappingId = "9AD4EF1F-AD86-4A69-B0DC-3F2DDFA2BA78", TargetValue = 11, SourceValue = "Vendor" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "7F3A2153-97D4-45BD-A857-B0162915DB6D", ColumnMappingId = "F2D9229A-CF2B-40E2-8BD2-69BE58FB57BD", TargetValue = 2, SourceValue = "Paid" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "A9229927-BE66-4C50-B9DA-B376270E39E1", ColumnMappingId = "F2D9229A-CF2B-40E2-8BD2-69BE58FB57BD", TargetValue = 4, SourceValue = "Bad Debts" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "C41B960E-F1DF-4A09-8A83-B5518CD70741", ColumnMappingId = "43FCA676-F85E-4AE5-8DCE-F6EB29E5A428", TargetValue = 8, SourceValue = "Closed Dead" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "0CA2FB6B-CCBC-4C9D-83A5-B6C5E0C4CC00", ColumnMappingId = "43FCA676-F85E-4AE5-8DCE-F6EB29E5A428", TargetValue = 6, SourceValue = "Closed Accepted" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "38CB5CE5-9E5D-400F-8197-B70D9A43B47A", ColumnMappingId = "254A6DD1-C239-47A0-9E70-2B5FF3B04E7F", TargetValue = 10, SourceValue = "Distributors, Dispatchers and Processors" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "40371897-C91C-4AB9-8C14-BB673AE5F137", ColumnMappingId = "592D2D25-6F91-405B-B845-B3C99C96391B", TargetValue = 9, SourceValue = "Closed Won" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "2DF131A0-ED6F-4567-B926-BBB2461E99CF", ColumnMappingId = "1B08DEA0-534E-42AC-B4CC-A480DAA5E326", TargetValue = 5, SourceValue = "Recycled" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "ACEA1FB4-00C8-4F86-9655-BCA9F6F57A8B", ColumnMappingId = "254A6DD1-C239-47A0-9E70-2B5FF3B04E7F", TargetValue = 4, SourceValue = "Brokers" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "EDC9C2A4-EB69-4924-8BA0-BE660DCAEDF4", ColumnMappingId = "254A6DD1-C239-47A0-9E70-2B5FF3B04E7F", TargetValue = 7, SourceValue = "Consulting" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "A9A9ED6A-568D-4158-B81C-BE7E578D8A90", ColumnMappingId = "88F3AB5C-797A-4B29-AE17-8A0C9E445DA7", TargetValue = 2, SourceValue = "New Business" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "B2DD5BC7-DD10-46DD-94E6-BFA1941656EF", ColumnMappingId = "592D2D25-6F91-405B-B845-B3C99C96391B", TargetValue = 4, SourceValue = "Value Proposition" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "02017AA0-A86E-43AD-A9C5-BFC2D2E68035", ColumnMappingId = "254A6DD1-C239-47A0-9E70-2B5FF3B04E7F", TargetValue = 11, SourceValue = "Doctor's Offices and Clinics" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "02ABF58B-249B-4727-AE60-C3EA0F796ECE", ColumnMappingId = "FC94027D-DE2D-427F-B17C-AD54B9709A43", TargetValue = 2, SourceValue = "Head Office" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "1CB6BDF6-6888-4FCC-9E36-CDAA65DA8FA7", ColumnMappingId = "BF5B63EE-7AC9-4CEB-9324-1B38A5655EF6", TargetValue = 5, SourceValue = "Hopeless" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "D854CCAD-85A6-4693-B09A-D547F8C2B41F", ColumnMappingId = "73BDF139-7374-4EE2-BC1D-636ACAABF059", TargetValue = 8, SourceValue = "Email" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "FAE09BD6-1E3B-4AF2-B7FC-D5B022AFE421", ColumnMappingId = "94A4C5FD-B8B3-4B1A-AA9F-458D7669E9BA", TargetValue = 5, SourceValue = "Failed" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "05F491E7-D80C-460E-BC64-D6340700EA81", ColumnMappingId = "94A4C5FD-B8B3-4B1A-AA9F-458D7669E9BA", TargetValue = 1, SourceValue = "Prepare" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "3175E4D9-A52F-490C-A049-D9594FEB605F", ColumnMappingId = "FC94027D-DE2D-427F-B17C-AD54B9709A43", TargetValue = 6, SourceValue = "Self Generated" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "1488D97C-D831-49D3-9139-DA645539B428", ColumnMappingId = "43FCA676-F85E-4AE5-8DCE-F6EB29E5A428", TargetValue = 4, SourceValue = "On Hold" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "B540A088-E89A-45FA-BD9C-DBA13105CACF", ColumnMappingId = "73BDF139-7374-4EE2-BC1D-636ACAABF059", TargetValue = 4, SourceValue = "Cold Call" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "0A278198-7820-4B5C-84C2-DBFDCEACCFE8", ColumnMappingId = "9AD4EF1F-AD86-4A69-B0DC-3F2DDFA2BA78", TargetValue = 7, SourceValue = "Press" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "8BCD2A8D-1CA1-4EC9-BB3E-DD2E175EA767", ColumnMappingId = "94A4C5FD-B8B3-4B1A-AA9F-458D7669E9BA", TargetValue = 4, SourceValue = "Closed" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "0AD6FB09-2F33-4644-BA25-E0F1EF2A4E97", ColumnMappingId = "254A6DD1-C239-47A0-9E70-2B5FF3B04E7F", TargetValue = 2, SourceValue = "Agriculture and Non-petrol Natural Resource Extraction" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "C9A7453E-AD3D-4C17-8632-E4FBE51738D7", ColumnMappingId = "88F3AB5C-797A-4B29-AE17-8A0C9E445DA7", TargetValue = 1, SourceValue = "Existing Business" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "B9BAE5BA-D504-4744-BB93-E8E804552A9B", ColumnMappingId = "254A6DD1-C239-47A0-9E70-2B5FF3B04E7F", TargetValue = 3, SourceValue = "Broadcasting Printing and Publishing" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "B6FA96A7-9798-4BA4-B3BB-EE5E6433BD5D", ColumnMappingId = "592D2D25-6F91-405B-B845-B3C99C96391B", TargetValue = 2, SourceValue = "Qualification" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "D8A1AE96-BA80-4591-938F-F319FA358813", ColumnMappingId = "254A6DD1-C239-47A0-9E70-2B5FF3B04E7F", TargetValue = 9, SourceValue = "Design, Direction and Creative Management" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "ED98B267-1F0B-49B0-851A-F648FD8826CB", ColumnMappingId = "94A4C5FD-B8B3-4B1A-AA9F-458D7669E9BA", TargetValue = 2, SourceValue = "Working" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "CE11DF10-DC54-4757-980C-FAC7C8E654BB", ColumnMappingId = "9AD4EF1F-AD86-4A69-B0DC-3F2DDFA2BA78", TargetValue = 5, SourceValue = "Partner" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "D061B7B3-6B58-421E-9031-FC9DD342840C", ColumnMappingId = "254A6DD1-C239-47A0-9E70-2B5FF3B04E7F", TargetValue = 12, SourceValue = "Durable Manufacturing" });
            Insert.IntoTable("PickListMapping").Row(new { PickListMappingId = "12A5FA24-8EE2-4FCF-B1BF-FD9509E7CFA3", ColumnMappingId = "43FCA676-F85E-4AE5-8DCE-F6EB29E5A428", TargetValue = 2, SourceValue = "Negotiation" });
        }
        public override void Down()
        {
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "AC4348C5-F8E1-42B8-8B4C-00F9035BC409" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "701B5F3B-F027-4502-8033-072E37241F35" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "B3FF8F1D-C8FD-4B8E-898D-07C8F7439787" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "1E011BD5-C541-4B7F-8966-0921D28369D4" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "D6BCD7DF-36E7-421E-8A23-0BEEB5EE05E7" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "00543CAB-B818-4907-812E-0ECF28252DE4" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "55292AEB-B29C-458E-9BCC-21001066D57E" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "F4C314C5-DDEF-48F9-8B44-230F87E9B80C" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "214B54C6-EFEB-40B4-99B1-25CB99610B14" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "B220E2DD-5EF9-486E-842A-285500B795D3" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "EDE5C8B6-0D16-42AD-BF5B-2943D857F9AF" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "3FAFAD70-FFDF-4DE5-85B1-299B87FDC127" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "88D2DF6C-84C8-48EC-A2EE-2BC29E7ED305" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "886D2FA4-3E54-460B-8910-2D5094E4D856" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "BDF30411-4803-44F4-80BE-34AEA7875B90" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "8F247850-9B69-40D0-89C7-3640160BA704" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "DB7A6842-40E1-4B63-A413-37743D20A86A" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "7B3152E1-1EED-4733-9F12-3CB876C68E42" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "F2E623BA-0F36-454F-90DC-3D7A9C5BAC46" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "C188D748-B25D-41D6-A214-3FFD8624C8EF" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "360E7416-3C79-42C5-96AE-4119013FE5FF" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "258B09C3-4EB1-40FE-B522-4A0B39981804" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "ED563CAD-48E5-4605-95B4-4A438A52EAF0" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "300E2678-9434-4F12-AC7D-4A7F89535634" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "CCF19DA0-68FD-4509-A6AA-4EFE66750EF1" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "1872A04D-8842-4D0F-B737-5182A2E6DFF7" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "41B83FD7-D0F4-4907-B367-5199D29DDE77" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "AA233206-00A9-4AC0-BA2C-52CA15FF6CDF" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "26D8AA12-CBA4-45DE-8BA5-56DF3C334473" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "05A57854-DBBF-4775-923B-5E46332BFACB" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "F7DCEA87-DA9C-49AD-84AF-6125D9CFB32F" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "6E7D1263-083D-4445-AD49-6372E0E07A2F" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "602B7868-2CC5-4403-B011-669E5FAA1601" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "AAA3B57A-A7E0-406D-9784-6DD1C8C6AA5C" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "FD971FD4-DDDD-406A-A076-711231B47B58" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "53A245D7-8B21-43D2-9E63-745C4F073B0D" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "CBF70A81-2AE3-493F-94A7-75D57B2193A0" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "09E5469E-8789-4DD7-88C4-761C89B32CC1" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "678084F2-2C4C-44C4-AE6B-7860FF732EF2" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "C73EF229-CDA6-45E4-995C-790DAF381703" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "260910CC-7619-4B9F-9343-80887AB4FB0E" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "8F60748C-DD83-48BB-A302-878C758D41EF" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "7BB017AF-10EF-4344-ACF4-89F1D90BF725" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "6444A0B0-5244-4BE9-8AED-92182F490D35" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "EA40A4E5-902B-44E1-AC28-9295BFFB669C" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "05FB3B66-E635-4E04-8414-95400719BAE8" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "7C82553E-E02D-4B91-98F9-984D2280C5FA" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "F192298C-A918-4D25-B1ED-99891EC70723" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "F33E5D7E-6084-4BCB-98E7-9B606FEA4F46" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "F2E658E1-9EDF-4CC8-AA50-9DB31A716FD1" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "5B87E511-8E0C-49EE-A920-A727AAB2091A" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "2B7D1AC0-00F1-4575-B962-A8629033C809" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "A7A684DC-5FDB-44C9-9869-AB3DE69EE710" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "B36A231E-CAE3-45C4-854D-AFBA021421EE" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "7F3A2153-97D4-45BD-A857-B0162915DB6D" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "A9229927-BE66-4C50-B9DA-B376270E39E1" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "C41B960E-F1DF-4A09-8A83-B5518CD70741" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "0CA2FB6B-CCBC-4C9D-83A5-B6C5E0C4CC00" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "38CB5CE5-9E5D-400F-8197-B70D9A43B47A" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "40371897-C91C-4AB9-8C14-BB673AE5F137" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "2DF131A0-ED6F-4567-B926-BBB2461E99CF" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "ACEA1FB4-00C8-4F86-9655-BCA9F6F57A8B" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "EDC9C2A4-EB69-4924-8BA0-BE660DCAEDF4" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "A9A9ED6A-568D-4158-B81C-BE7E578D8A90" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "B2DD5BC7-DD10-46DD-94E6-BFA1941656EF" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "02017AA0-A86E-43AD-A9C5-BFC2D2E68035" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "02ABF58B-249B-4727-AE60-C3EA0F796ECE" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "1CB6BDF6-6888-4FCC-9E36-CDAA65DA8FA7" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "D854CCAD-85A6-4693-B09A-D547F8C2B41F" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "FAE09BD6-1E3B-4AF2-B7FC-D5B022AFE421" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "05F491E7-D80C-460E-BC64-D6340700EA81" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "3175E4D9-A52F-490C-A049-D9594FEB605F" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "1488D97C-D831-49D3-9139-DA645539B428" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "B540A088-E89A-45FA-BD9C-DBA13105CACF" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "0A278198-7820-4B5C-84C2-DBFDCEACCFE8" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "8BCD2A8D-1CA1-4EC9-BB3E-DD2E175EA767" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "0AD6FB09-2F33-4644-BA25-E0F1EF2A4E97" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "C9A7453E-AD3D-4C17-8632-E4FBE51738D7" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "B9BAE5BA-D504-4744-BB93-E8E804552A9B" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "B6FA96A7-9798-4BA4-B3BB-EE5E6433BD5D" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "D8A1AE96-BA80-4591-938F-F319FA358813" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "ED98B267-1F0B-49B0-851A-F648FD8826CB" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "CE11DF10-DC54-4757-980C-FAC7C8E654BB" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "D061B7B3-6B58-421E-9031-FC9DD342840C" });
            Delete.FromTable("PickListMapping").Row(new { PickListMappingId = "12A5FA24-8EE2-4FCF-B1BF-FD9509E7CFA3" });
        }
    }
}
